<?php include_once('header.php'); ?>
<?php include_once('left_navigation.php'); ?>
<?php
include('../classess/class_affiliate_user.php');
?>
<div class="col-lg-12"><!-- Start Middle Content Div-->
    <div class="box">
        <div class="row">
            <div class="col-lg-12" style="margin-top:-20px; text-align:center;">
                <div class="box" style="font-size:16px;">
					Your Refrence URL is 
					<a href="<?php echo ReferenceLink; ?>" target="_blank" style="text-decoration:none; color:blue; "><?php echo ReferenceLink; ?></a>	
                </div>
                <div class="box" style="font-size:16px;">
                Follow these subscribe people by email/chat…etc.  Click on view info see the interest and follow up accordingly.
           </div>
                </div>
            <div class="col-lg-12">
                <div class="box">
                    <div class="box-header" data-original-title>
                        <h2><i class="fa fa-user"></i><span class="break"></span>Affiliate Users</h2>
                        <div class="box-icon">
                            <a href="table.html#" class="btn-minimize"><i class="fa fa-chevron-up"></i></a>
                            <a href="table.html#" class="btn-close"><i class="fa fa-times"></i></a>
                        </div>
                    </div>
                    <div class="box-content">
                        <div class="search_box">
                            <div class="fl_left sel_label_search">Search:</div>
                            <div class="fl_left" style="width:60%;">									
                                <form method="POST" action="<?php echo $_SERVER['PHP_SELF'] . '?home=1'; ?>" id="search_form" name="search_form">
                                    <input type="text" name="search_value" id="search_value" placeholder="Search" value="<?php if (isset($_POST['search_value'])) {
                        echo $_POST['search_value'];
                    } else {
                        echo '';
                    } if (isset($_GET['srch_value'])) {
                        echo $_GET['srch_value'];
                    } else {
                        echo '';
                    } ?>">&nbsp;
                                    <input type="submit" name="submit_search" id="submit_search" class="btn btn-blue srch_btn" value="Search">
                                </form>

                            </div>
                            <div class="clear_fix"></div>
                        </div>
                        <table class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>S No.</th>
                                    <th>User Name</th>
                                    <th>Email</th>
                                 <!--   <th>Commission Percentage</th>
                                    <th>Commission</th> -->
                                    <th>Is Active</th>
                                    <th>Is Paid</th>
                                    <th>View Info</th>
                                </tr>
                            </thead>   
                            <tbody>
                                <?php
                                $rec_limit = 25;

                                $condition_search = '';
                                $value = '';
                                if (isset($_POST['search_value'])) {
                                    $value = trim($_POST['search_value']);

                                    if (!empty($value)) {
                                        $cond_where = 'AND ';
                                        $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                    }
                                }

                                if (isset($_GET['srch_value'])) {
                                    $value = $_GET['srch_value'];

                                    if (!empty($value)) {
                                        $cond_where = 'AND ';

                                        $condition_search = $cond_where . " (username like '%" . $value . "%' OR email like '%" . $value . "%')";
                                    }
                                }

                                $select_count_course = "SELECT count(*) FROM tbl_user WHERE reffered_by='a_" . $_SESSION['id'] . "'  " . $condition_search;
                                $result_count_course = mysql_query($select_count_course);

                                $row = mysql_fetch_array($result_count_course);
                                $rec_count = $row[0];

                                if (isset($_GET['page'])) {
                                    $page = $_GET['page'] + 1;
                                    $offset = $rec_limit * $page;
                                } else {
                                    $page = 0;
                                    $offset = 0;
                                }

                                $serial_number = $page * $rec_limit;

                                $left_rec = $rec_count - ($page * $rec_limit);

                               // $select_trainer = "SELECT * FROM tbl_user WHERE reffered_by='a_" . $_SESSION['id'] . "' " . $condition_search . " ORDER BY id DESC LIMIT " . $offset . ", " . $rec_limit;
                               
							  /* $select_trainer = "SELECT a.*,c.*, b.*, b.id as comm_id 
                                    FROM tbl_user_details as a,tbl_user as c, tbl_commission as b 
                                    WHERE  b.user_admin_id='a_" . $_SESSION['id'] . "' and c.reffered_by='a_" . $_SESSION['id'] . "' 
                                    GROUP by c.id
                                    ORDER BY c.id DESC LIMIT " . $offset . ", " . $rec_limit;
*/

$select_trainer = "SELECT * FROM tbl_user AS a
WHERE  a.reffered_by='a_" . $_SESSION['id'] . "' GROUP by a.id ORDER BY a.id DESC LIMIT " . $offset . ", " . $rec_limit;



                                $query_trainer = mysql_query($select_trainer) or die(mysql_error());

                                $i = 1;
                                if (mysql_num_rows($query_trainer) > 0) {
                                    $total_amount = '0';
                                    $pending_amount = '0';
                                    $chk_id = '';
                                    while ($row = mysql_fetch_array($query_trainer)) {
                
                                        echo '
						<tr>
						<td>' . $i . '</td>
						<td>' . $row['username'] . '</td>
						<td>' . $row['email'] . '</td>';
					 
                                        
                                        echo '						<td>';
                                        if ($row['is_active']) {
                                            echo '<span class="label label-success">Active</span>';
                                        } else {
                                            echo '<span class="label label-default">Inactive</span>';
                                        }
                                        echo '</td>
												<td>';
                                        if ($row['is_paid']) {
                                            echo '<span class="label label-success">Yes</span>';
                                        } else {
                                            echo '<span class="label label-default">No</span>';
                                        }
                                        echo '</td>';
	echo '<td><a href="user_course.php?home=1&user_id=' . $row['id'] . '">View Info</a></td>
	</tr>
										';
                                        $i++;
                                    }
                                } else {
                                    echo '<tr>
					<td colspan="9" style="text-align:center;">No Records Found</td>
									</tr>';
                                }
                                ?>						
                            </tbody>
                        </table>  
						</br></br>
	<?php
		$select_value = "SELECT * FROM tbl_affiliate  WHERE id = '" . $_SESSION['id'] . "'";
					
		$query_value = mysql_query($select_value) or die(mysql_error());
        $withdrawData  = mysql_fetch_assoc($query_value);			      
	?>
	<div>
		<p><b>Minimum Amount:</b>  $ <?php echo $withdrawData['withdraw_min_amount'];; ?></p>
		<p><b>Maximum Amount:</b>  $ <?php echo $withdrawData['withdraw_max_amount']; ?></p>
	</div>
						
                        <!--
						<b>Total Amount :</b> $ <?php echo $total_amount; ?>
                        <br/><b>Pending Amount :</b> $ <?php echo $pending_amount; ?>
                        -->
                        
                            <?php
                        echo '<ul class="pagination">';
                        if ($rec_count > $rec_limit) {
                            if ($page > 0 && $left_rec > $rec_limit) {
                                $last = $page - 2;
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?home=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li> ';
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?home=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($page == 0) {
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?home=1&page=' . $page . '&srch_value=' . $value . '" class="anc_click">Next</a></li>';
                            } else if ($left_rec < $rec_limit || $left_rec == $rec_limit) {
                                $last = $page - 2;
                                echo '<li><a href="' . $_SERVER["PHP_SELF"] . '?home=1&page=' . $last . '&srch_value=' . $value . '" class="anc_click">Prev</a></li>';
                            }
                        }
                        echo '</ul>';
                        ?>
                    </div>
                </div>
            </div><!--/col-->

        </div><!--/row-->


    </div><!-- End Box Div-->
</div><!-- End Middle Content Div-->
<?php include_once('footer.php'); ?>
<script>
    $ = jQuery.noConflict();
    $(document).ready(function() {
        $('.close').click(function() {
            $('.alert-info').addClass('hide');
        });

        $('#add_user').click(function() {
            document.add_course_form.submit();
        });

        $('#submit_course_search').click(function() {
            document.search_course_form.submit()
        });
    });


</script>